Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	2970
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	301.8 KiB
Average record size in memory	104.0 B

Variable types

Numeric	13

Warnings

`gross_revenue` is highly correlated with `qtde_invoices` and 1 other fields	High correlation
`qtde_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qtde_items` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`qtde_products` is highly correlated with `qtde_invoices`	High correlation
`avg_ticket` is highly correlated with `qtde_returns` and 1 other fields	High correlation
`qtde_returns` is highly correlated with `avg_ticket` and 1 other fields	High correlation
`avg_basket_size` is highly correlated with `avg_ticket` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `qtde_invoices` and 3 other fields	High correlation
`recency_days` is highly correlated with `qtde_invoices`	High correlation
`qtde_invoices` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qtde_items` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qtde_products` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly correlated with `avg_unique_basket_size`	High correlation
`avg_recency_days` is highly correlated with `frequency`	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `qtde_products` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `qtde_invoices` and 2 other fields	High correlation
`qtde_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qtde_items` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qtde_products` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_recency_days` is highly correlated with `frequency`	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly correlated with `qtde_items`	High correlation
`avg_unique_basket_size` is highly correlated with `qtde_products`	High correlation
`qtde_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qtde_returns` is highly correlated with `avg_ticket` and 3 other fields	High correlation
`avg_ticket` is highly correlated with `qtde_returns` and 3 other fields	High correlation
`gross_revenue` is highly correlated with `qtde_invoices` and 5 other fields	High correlation
`qtde_products` is highly correlated with `qtde_invoices` and 3 other fields	High correlation
`avg_basket_size` is highly correlated with `qtde_returns` and 3 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `qtde_products`	High correlation
`qtde_items` is highly correlated with `qtde_invoices` and 5 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 53.45322416)	Skewed
`frequency` is highly skewed (γ1 = 24.88427542)	Skewed
`qtde_returns` is highly skewed (γ1 = 51.80645659)	Skewed
`avg_basket_size` is highly skewed (γ1 = 44.69064048)	Skewed
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`avg_ticket` has unique values	Unique
`recency_days` has 34 (1.1%) zeros	Zeros
`qtde_returns` has 1481 (49.9%) zeros	Zeros

Reproduction

Analysis started	2021-06-06 18:35:12.343806
Analysis finished	2021-06-06 18:35:32.435836
Duration	20.09 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	2970
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2317.86532

Minimum	0
Maximum	5716
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	185.45
Q1	929.25
median	2120.5
Q3	3537.75
95-th percentile	5036.1
Maximum	5716
Range	5716
Interquartile range (IQR)	2608.5

Descriptive statistics

Standard deviation	1555.136615
Coefficient of variation (CV)	0.6709348474
Kurtosis	-1.010761417
Mean	2317.86532
Median Absolute Deviation (MAD)	1271
Skewness	0.3420323534
Sum	6884060
Variance	2418449.89
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
635	1	< 0.1%
625	1	< 0.1%
4668	1	< 0.1%
627	1	< 0.1%
2676	1	< 0.1%
629	1	< 0.1%
2678	1	< 0.1%
4727	1	< 0.1%
2680	1	< 0.1%
Other values (2960)	2960	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5716	1	< 0.1%
5697	1	< 0.1%
5687	1	< 0.1%
5681	1	< 0.1%
5660	1	< 0.1%
5656	1	< 0.1%
5650	1	< 0.1%
5639	1	< 0.1%
5638	1	< 0.1%
5628	1	< 0.1%

customer_id
Real number (ℝ_≥0)

UNIQUE

Distinct	2970
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15270.71818

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	12347
5-th percentile	12619.45
Q1	13799.75
median	15220.5
Q3	16767.75
95-th percentile	17964.55
Maximum	18287
Range	5940
Interquartile range (IQR)	2968

Descriptive statistics

Standard deviation	1718.703373
Coefficient of variation (CV)	0.112548955
Kurtosis	-1.205496241
Mean	15270.71818
Median Absolute Deviation (MAD)	1487
Skewness	0.03170847426
Sum	45354033
Variance	2953941.285
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16384	1	< 0.1%
13363	1	< 0.1%
12931	1	< 0.1%
12933	1	< 0.1%
12935	1	< 0.1%
14984	1	< 0.1%
17033	1	< 0.1%
13704	1	< 0.1%
12939	1	< 0.1%
17037	1	< 0.1%
Other values (2960)	2960	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18269	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2964
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2748.69071

Minimum	6.2
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	6.2
5-th percentile	229.8075
Q1	571.02
median	1088.53
Q3	2307.675
95-th percentile	7217.565
Maximum	279138.02
Range	279131.82
Interquartile range (IQR)	1736.655

Descriptive statistics

Standard deviation	10578.74876
Coefficient of variation (CV)	3.848650093
Kurtosis	354.076566
Mean	2748.69071
Median Absolute Deviation (MAD)	674.05
Skewness	16.78066089
Sum	8163611.41
Variance	111909925.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
745.06	2	0.1%
331	2	0.1%
379.65	2	0.1%
734.94	2	0.1%
533.33	2	0.1%
731.9	2	0.1%
1414.43	1	< 0.1%
923.41	1	< 0.1%
471.51	1	< 0.1%
13375.87	1	< 0.1%
Other values (2954)	2954	99.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6.2	1	< 0.1%
13.3	1	< 0.1%
15	1	< 0.1%
36.56	1	< 0.1%
45	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
140438.72	1	< 0.1%
124564.53	1	< 0.1%
117375.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%

recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	272
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.31447811

Minimum	0
Maximum	373
Zeros	34
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	11
median	31
Q3	81
95-th percentile	242
Maximum	373
Range	373
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	77.75581705
Coefficient of variation (CV)	1.208993983
Kurtosis	2.774121666
Mean	64.31447811
Median Absolute Deviation (MAD)	26
Skewness	1.797141709
Sum	191014
Variance	6045.967086
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.3%
4	87	2.9%
2	85	2.9%
3	85	2.9%
8	76	2.6%
10	67	2.3%
7	66	2.2%
9	66	2.2%
17	64	2.2%
22	55	1.9%
Other values (262)	2220	74.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	34	1.1%
1	99	3.3%
2	85	2.9%
3	85	2.9%
4	87	2.9%
5	43	1.4%
7	66	2.2%
8	76	2.6%
9	66	2.2%
10	67	2.3%

Value	Count	Frequency (%)
373	2	0.1%
372	4	0.1%
371	1	< 0.1%
368	1	< 0.1%
366	4	0.1%
365	2	0.1%
364	1	< 0.1%
360	1	< 0.1%
359	1	< 0.1%
358	4	0.1%

qtde_invoices
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	56
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.721885522

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	205
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.855303226
Coefficient of variation (CV)	1.547619782
Kurtosis	190.8826625
Mean	5.721885522
Median Absolute Deviation (MAD)	2
Skewness	10.76805433
Sum	16994
Variance	78.41639523
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	786	26.5%
3	499	16.8%
4	393	13.2%
5	237	8.0%
1	190	6.4%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%
Other values (46)	332	11.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	190	6.4%
2	786	26.5%
3	499	16.8%
4	393	13.2%
5	237	8.0%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

qtde_items
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1665
Distinct (%)	56.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1606.085185

Minimum	1
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	101.45
Q1	296.25
median	638
Q3	1398.75
95-th percentile	4407.2
Maximum	196844
Range	196843
Interquartile range (IQR)	1102.5

Descriptive statistics

Standard deviation	5882.021385
Coefficient of variation (CV)	3.662334626
Kurtosis	467.3049728
Mean	1606.085185
Median Absolute Deviation (MAD)	419
Skewness	17.88131633
Sum	4770073
Variance	34598175.58
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
88	9	0.3%
150	9	0.3%
246	8	0.3%
84	8	0.3%
260	8	0.3%
288	8	0.3%
272	8	0.3%
200	7	0.2%
134	7	0.2%
Other values (1655)	2887	97.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	2	0.1%
12	2	0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%
25	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
79963	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
62812	1	< 0.1%
58243	1	< 0.1%
57785	1	< 0.1%

qtde_products
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	469
Distinct (%)	15.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.683165

Minimum	1
Maximum	7837
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	29
median	67
Q3	135
95-th percentile	382
Maximum	7837
Range	7836
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	269.7992435
Coefficient of variation (CV)	2.199154575
Kurtosis	354.9485422
Mean	122.683165
Median Absolute Deviation (MAD)	44
Skewness	15.70855259
Sum	364369
Variance	72791.63181
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	45	1.5%
20	38	1.3%
35	35	1.2%
19	33	1.1%
15	33	1.1%
29	33	1.1%
11	32	1.1%
26	31	1.0%
27	30	1.0%
16	29	1.0%
Other values (459)	2631	88.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	6	0.2%
2	14	0.5%
3	16	0.5%
4	17	0.6%
5	26	0.9%
6	29	1.0%
7	18	0.6%
8	19	0.6%
9	27	0.9%
10	27	0.9%

Value	Count	Frequency (%)
7837	1	< 0.1%
5670	1	< 0.1%
5095	1	< 0.1%
4577	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1636	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
UNIQUE

Distinct	2970
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51.8894298

Minimum	2.150588235
Maximum	56157.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	2.150588235
5-th percentile	4.917434212
Q1	13.11982258
median	17.97733464
Q3	24.98612169
95-th percentile	90.49558333
Maximum	56157.5
Range	56155.34941
Interquartile range (IQR)	11.86629911

Descriptive statistics

Standard deviation	1036.759857
Coefficient of variation (CV)	19.98017439
Kurtosis	2891.680828
Mean	51.8894298
Median Absolute Deviation (MAD)	5.990148388
Skewness	53.45322416
Sum	154111.6065
Variance	1074871
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17.49275862	1	< 0.1%
33.53571429	1	< 0.1%
17.62896175	1	< 0.1%
28.89968794	1	< 0.1%
46.07413043	1	< 0.1%
25.77538462	1	< 0.1%
8.745172414	1	< 0.1%
18.15061538	1	< 0.1%
17.94344444	1	< 0.1%
15.9845	1	< 0.1%
Other values (2960)	2960	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
56157.5	1	< 0.1%
4453.43	1	< 0.1%
3202.92	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%

avg_recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	1258
Distinct (%)	42.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67.33840526

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	25.94642857
median	48.26785714
Q3	85.33333333
95-th percentile	201
Maximum	366
Range	365
Interquartile range (IQR)	59.38690476

Descriptive statistics

Standard deviation	63.53609292
Coefficient of variation (CV)	0.9435342681
Kurtosis	4.890127492
Mean	67.33840526
Median Absolute Deviation (MAD)	26.26785714
Skewness	2.063409073
Sum	199995.0636
Variance	4036.835104
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	25	0.8%
4	22	0.7%
70	21	0.7%
7	20	0.7%
35	19	0.6%
49	18	0.6%
46	17	0.6%
11	17	0.6%
21	17	0.6%
1	16	0.5%
Other values (1248)	2778	93.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	16	0.5%
1.5	1	< 0.1%
2	13	0.4%
2.5	1	< 0.1%
2.601398601	1	< 0.1%
3	15	0.5%
3.321428571	1	< 0.1%
3.330357143	1	< 0.1%
3.5	2	0.1%
4	22	0.7%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
362	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1225
Distinct (%)	41.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1137645194

Minimum	0.005449591281
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0.005449591281
5-th percentile	0.008894823607
Q1	0.01633986928
median	0.02589835169
Q3	0.04938789715
95-th percentile	1
Maximum	17
Range	16.99455041
Interquartile range (IQR)	0.03304802787

Descriptive statistics

Standard deviation	0.4080910039
Coefficient of variation (CV)	3.587155346
Kurtosis	989.6727708
Mean	0.1137645194
Median Absolute Deviation (MAD)	0.0121968864
Skewness	24.88427542
Sum	337.8806226
Variance	0.1665382675
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	198	6.7%
0.02777777778	17	0.6%
0.0625	17	0.6%
0.02380952381	16	0.5%
0.03448275862	15	0.5%
0.08333333333	15	0.5%
0.09090909091	15	0.5%
0.02941176471	14	0.5%
0.03571428571	13	0.4%
0.02564102564	13	0.4%
Other values (1215)	2637	88.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
3	1	< 0.1%
2	6	0.2%
1.142857143	1	< 0.1%
1	198	6.7%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%
0.5	3	0.1%

qtde_returns
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	214
Distinct (%)	7.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	62.13670034

Minimum	0
Maximum	80995
Zeros	1481
Zeros (%)	49.9%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	9
95-th percentile	100.55
Maximum	80995
Range	80995
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	1512.241801
Coefficient of variation (CV)	24.33733676
Kurtosis	2766.459377
Mean	62.13670034
Median Absolute Deviation (MAD)	1
Skewness	51.80645659
Sum	184546
Variance	2286875.265
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1481	49.9%
1	164	5.5%
2	149	5.0%
3	105	3.5%
4	89	3.0%
6	78	2.6%
5	61	2.1%
12	51	1.7%
7	43	1.4%
8	43	1.4%
Other values (204)	706	23.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1481	49.9%
1	164	5.5%
2	149	5.0%
3	105	3.5%
4	89	3.0%
5	61	2.1%
6	78	2.6%
7	43	1.4%
8	43	1.4%
9	41	1.4%

Value	Count	Frequency (%)
80995	1	< 0.1%
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%

avg_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1974
Distinct (%)	66.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	249.3205793

Minimum	1
Maximum	40498.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	44
Q1	103.2625
median	172
Q3	281.4583333
95-th percentile	599.46
Maximum	40498.5
Range	40497.5
Interquartile range (IQR)	178.1958333

Descriptive statistics

Standard deviation	791.3706789
Coefficient of variation (CV)	3.174108937
Kurtosis	2256.993743
Mean	249.3205793
Median Absolute Deviation (MAD)	82.625
Skewness	44.69064048
Sum	740482.1206
Variance	626267.5514
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
114	10	0.3%
82	9	0.3%
73	9	0.3%
86	9	0.3%
136	8	0.3%
60	8	0.3%
88	8	0.3%
75	8	0.3%
288	7	0.2%
Other values (1964)	2883	97.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2	0.1%
2	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
40498.5	1	< 0.1%
6009.333333	1	< 0.1%
4282	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2801	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%

avg_unique_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1010
Distinct (%)	34.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.15401143

Minimum	1
Maximum	299.7058824
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	3.346969697
Q1	10
median	17.2
Q3	27.75
95-th percentile	56.9325
Maximum	299.7058824
Range	298.7058824
Interquartile range (IQR)	17.75

Descriptive statistics

Standard deviation	19.50983265
Coefficient of variation (CV)	0.8806455983
Kurtosis	27.70524325
Mean	22.15401143
Median Absolute Deviation (MAD)	8.2
Skewness	3.498956413
Sum	65797.41393
Variance	380.6335699
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	53	1.8%
14	40	1.3%
11	38	1.3%
9	33	1.1%
20	33	1.1%
1	32	1.1%
18	31	1.0%
10	30	1.0%
16	29	1.0%
17	28	0.9%
Other values (1000)	2623	88.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	32	1.1%
1.2	1	< 0.1%
1.25	1	< 0.1%
1.333333333	2	0.1%
1.5	8	0.3%
1.568181818	1	< 0.1%
1.571428571	1	< 0.1%
1.666666667	4	0.1%
1.833333333	1	< 0.1%
2	24	0.8%

Value	Count	Frequency (%)
299.7058824	1	< 0.1%
259	1	< 0.1%
203.5	1	< 0.1%
148	1	< 0.1%
145	1	< 0.1%
136.125	1	< 0.1%
135.5	1	< 0.1%
127	1	< 0.1%
122	1	< 0.1%
118	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_items	qtde_products	avg_ticket	avg_recency_days	frequency	qtde_returns	avg_basket_size	avg_unique_basket_size
0	0	17850	5391.21	372.0	34.0	1733.0	297.0	18.152222	35.500000	17.000000	40.0	50.970588	8.735294
1	1	13047	3232.59	56.0	9.0	1390.0	171.0	18.904035	27.250000	0.028302	35.0	154.444444	19.000000
2	2	12583	6705.38	2.0	15.0	5028.0	232.0	28.902500	23.187500	0.040323	50.0	335.200000	15.466667
3	3	13748	948.25	95.0	5.0	439.0	28.0	33.866071	92.666667	0.017921	0.0	87.800000	5.600000
4	4	15100	876.00	333.0	3.0	80.0	3.0	292.000000	8.600000	0.073171	22.0	26.666667	1.000000
5	5	15291	4623.30	25.0	14.0	2102.0	102.0	45.326471	23.200000	0.040115	29.0	150.142857	7.285714
6	6	14688	5630.87	7.0	21.0	3621.0	327.0	17.219786	18.300000	0.057221	399.0	172.428571	15.571429
7	7	17809	5411.91	16.0	12.0	2057.0	61.0	88.719836	35.700000	0.033520	41.0	171.416667	5.083333
8	8	15311	60767.90	0.0	91.0	38194.0	2379.0	25.543464	4.144444	0.243316	474.0	419.714286	26.142857
9	9	16098	2005.63	87.0	7.0	613.0	67.0	29.934776	47.666667	0.024390	0.0	87.571429	9.571429

Last rows

	df_index	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_items	qtde_products	avg_ticket	avg_recency_days	frequency	qtde_returns	avg_basket_size	avg_unique_basket_size
2960	5628	17727	1060.25	15.0	1.0	645.0	66.0	16.064394	6.0	1.000000	6.0	645.000000	66.0
2961	5638	17232	421.52	2.0	2.0	203.0	36.0	11.708889	12.0	0.153846	0.0	101.500000	18.0
2962	5639	17468	137.00	10.0	2.0	116.0	5.0	27.400000	4.0	0.400000	0.0	58.000000	2.5
2963	5650	13596	697.04	5.0	2.0	406.0	166.0	4.199036	7.0	0.250000	0.0	203.000000	83.0
2964	5656	14893	1237.85	9.0	2.0	799.0	73.0	16.956849	2.0	0.666667	0.0	399.500000	36.5
2965	5660	12479	473.20	11.0	1.0	382.0	30.0	15.773333	4.0	1.000000	34.0	382.000000	30.0
2966	5681	14126	706.13	7.0	3.0	508.0	15.0	47.075333	3.0	0.750000	50.0	169.333333	5.0
2967	5687	13521	1092.39	1.0	3.0	733.0	435.0	2.511241	4.5	0.300000	0.0	244.333333	145.0
2968	5697	15060	301.84	8.0	4.0	262.0	120.0	2.515333	1.0	2.000000	0.0	65.500000	30.0
2969	5716	12558	269.96	7.0	1.0	196.0	11.0	24.541818	6.0	1.000000	196.0	196.000000	11.0

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows